Tabela LContractServService

Definicja tabeli LContractServService

Name

LContractServService

Code

LContractServService

Comment

 


Lista kolumn tabeli LContractServService

Name

Code

LContractServServiceID

LContractServServiceID

ContractorID

ContractorID

ServID

ServID

ContractID

ContractID

ResourceID

ResourceID

StartDT

StartDT

StopDT

StopDT

Active

Active

Comments

Comments

ContractServID

ContractServID

Con_ContractServID

Con_ContractServID

Con_ContractorCode

Con_ContractorCode

Con_PositionInContract

Con_PositionInContract

ContractorCode

ContractorCode

UnitsCount

UnitsCount


Kolumna LContractServServiceID tabeli LContractServService

Definicja kolumny LContractServServiceID tabeli LContractServService

Name

LContractServServiceID

Code

LContractServServiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractorID tabeli LContractServService

Definicja kolumny ContractorID tabeli LContractServService

Name

ContractorID

Code

ContractorID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli LContractServService

Definicja kolumny ServID tabeli LContractServService

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractID tabeli LContractServService

Definicja kolumny ContractID tabeli LContractServService

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceID tabeli LContractServService

Definicja kolumny ResourceID tabeli LContractServService

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli LContractServService

Definicja kolumny StartDT tabeli LContractServService

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LContractServService

Definicja kolumny StopDT tabeli LContractServService

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Active tabeli LContractServService

Definicja kolumny Active tabeli LContractServService

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna Comments tabeli LContractServService

Definicja kolumny Comments tabeli LContractServService

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ContractServID tabeli LContractServService

Definicja kolumny ContractServID tabeli LContractServService

Name

ContractServID

Code

ContractServID

Data Type

NUMBER(10)

Mandatory

No

Comment

Swiadczenie szczególowe


Kolumna Con_ContractServID tabeli LContractServService

Definicja kolumny Con_ContractServID tabeli LContractServService

Name

Con_ContractServID

Code

Con_ContractServID

Data Type

NUMBER(10)

Mandatory

No

Comment

Swiadczenie kontraktowe


Kolumna Con_ContractorCode tabeli LContractServService

Definicja kolumny Con_ContractorCode tabeli LContractServService

Name

Con_ContractorCode

Code

Con_ContractorCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Kod produktu kontraktowego


Kolumna Con_PositionInContract tabeli LContractServService

Definicja kolumny Con_PositionInContract tabeli LContractServService

Name

Con_PositionInContract

Code

Con_PositionInContract

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ContractorCode tabeli LContractServService

Definicja kolumny ContractorCode tabeli LContractServService

Name

ContractorCode

Code

ContractorCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Kod produktu szczególowego


Kolumna UnitsCount tabeli LContractServService

Definicja kolumny UnitsCount tabeli LContractServService

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Wartosci domyslnej krotnosci swiadczenia domyslnego kodowanego dla danego zasobu. Wartosc ta nadpisuje krotnosc zasobu która do tej pory byla uzywana jako krotnosc swiadczenia.


Lista kluczy tabeli LContractServService

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LContractServService

Definicja klucza Identifier_1 tabeli LContractServService

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment